﻿CREATE TABLE [dbo].[UserRoomLikes] (
    [RoomId] INT NOT NULL,
    [UserId] INT NOT NULL,
    CONSTRAINT [PK_UserRoomLikes] PRIMARY KEY CLUSTERED ([RoomId] ASC, [UserId] ASC),
    CONSTRAINT [FK_UserRoomLikes_Room] FOREIGN KEY ([RoomId]) REFERENCES [dbo].[Room] ([RoomId]),
    CONSTRAINT [FK_UserRoomLikes_User] FOREIGN KEY ([UserId]) REFERENCES [dbo].[User] ([UserId])
);

